Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
BusinessUnitGroupID (FK) | A unique system assigned identifier for a group of BusinessUnits. | ID_BSNGP | Identity | integer | BusinessUnitGroupItem(AS_BSNGP_ITM) |
BusinessUnitGroupID (FK)(PK) | A unique system assigned identifier for a group of BusinessUnits. | ID_BSNGP | Identity | integer | BusinessUnitGroup(CO_BSNGP) |
POSItemIDQualifier (PK) | A secondary qualifier on the POSItemID which denotes a separate item. Eg: When single bottles & six-packs of the same beverage both have the same UPC or other barcode, the POSItemIDQualifier holds denotes the two different items. | ID_ITM_PS_QFR | Identity | integer | |
POSItemID (PK) | The barcode, point of sale scan code or other keyed identifying number used at POS and the internal stock keping ItemID for the item. Will generally be filled with the GTIN (UPC, EAN etc) for an item -- but it is not mandatory -- A retailer may develop and maintain its own set of POS identifiers. | ID_ITM_PS | IdentityGTIN | varchar(14) | |
ItemSellingPricesID (FK) | A unique system assigned identifier for the ItemSellingPrices. | ID_ITM_SL_PRC | Identity | integer | ItemSellingPrices(RU_ITM_SL_PRC) |
ItemSellingRuleID (FK) | A unique system assigned identifier for the ItemSellingPrices. | ID_RU_ITM_SL | Identity | integer | ItemSellingRule(RU_ITM_SL) |
ItemID (FK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | BusinessUnitGroupItem(AS_BSNGP_ITM) |
EffectiveDateTime (FK) | The date from which the BusinessUnits in the group carry the Item. | TS_EF | EffectiveDateTime | datetime | BusinessUnitGroupItem(AS_BSNGP_ITM) |